SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51803 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51803 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671623,512825,946694,66774,225107,106418,264447,343820,877007,85550,580407,905479,933235,450730,1012620,156352,499337,464064,548502,885234,1039878,1043992,796011,993830,813131,358504,627194,626847,1016718,564228,315422,533949,541457,302672,497810,15690,20823,213774,19483,146214,436104,292405,10199,356188,4927,576605,752749,1042420,292958,328787,83144,94374,621952,900680,130245,24870,92952,975903,778069,483411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]