SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012423 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012423 [ RunTime:0.001403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145174,354975,983965,633458,778336,681513,1019098,7050,659949,245428,250165,949435,677337,516539,513724,301427,552210,723860,63104,862454,91453,681822,312525,877211,278173,1003215,577898,751477,945201,701749,729490,862768,1045782,399303,350203,17392,598504,711191,510139,860515,521045,147104,6454,151691,34796,540432,703117,896949,152846,306651,114115,186205,943791,78895,859172,498324,609189,166187,811076,1028544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]