SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404519 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404519 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408810,461878,840972,544431,970870,395688,578916,1036705,214755,237661,926623,531562,128678,121162,35200,477892,430107,1004943,628766,909963,598901,1043638,557314,182678,82277,316317,54888,365374,156861,226860,51824,617377,815908,25123,562029,192225,159009,116968,671830,372674,468197,643989,455234,970417,684482,139616,480231,185541,266542,159059,698226,645872,589909,171328,531066,808924,487643,350894,686183,1045325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]