SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 749881 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 749881 [ RunTime:0.002439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107518,324436,641053,598122,813016,178301,267165,340155,201756,359578,445926,538568,1021999,963991,654516,884020,879268,439413,686111,952953,862630,940012,77289,877508,459071,160894,957156,299974,1048346,321075,638100,786384,157589,668473,802574,683501,384575,887768,832798,686239,112168,413852,687697,89877,619452,301327,290665,272306,240270,59022,552899,125543,887397,456764,899487,947788,1005052,698409,407142,480149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 749881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 749881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]