SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545576 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545576 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911134,316317,299225,271538,234053,883147,523144,803254,727558,666526,195718,438898,425226,469381,1043096,464838,467916,604991,925461,850599,116434,1044382,355279,193786,814445,216431,347595,636644,12860,391410,959872,431007,1027000,494056,959352,495908,952254,219002,688730,542991,112095,350192,853500,874459,913739,666736,37767,473730,178948,537,684624,297704,941774,614033,246387,1025193,305414,600594,327465,882056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]