SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014417 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014417 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014454,454139,105613,790160,700107,382330,904160,446835,820519,525290,496321,925808,714739,794274,903918,448337,811403,295687,242354,577546,291576,64711,1046220,798580,542909,357019,901098,431569,424540,1833,317122,809092,1009136,582305,230828,594424,106557,858243,397088,899074,561171,524229,40345,50281,90148,16065,64636,187464,236160,204338,450303,994918,773751,297166,119943,329853,6927,116356,76037,537246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]