SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542041 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542041 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771543,178999,1038994,739537,1008019,738832,447969,533340,683830,109100,767702,549824,182892,852288,583754,202724,131861,936592,610800,959728,433081,773314,828970,903669,567065,874850,366899,691849,154569,680703,305339,463485,64444,113636,878563,857911,477521,186824,166138,490759,1029359,919910,91836,640381,701438,546662,878532,818633,768445,764096,1043980,887568,570077,943472,85173,90985,66851,275844,733657,778872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]