SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046251 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046251 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430276,666677,71533,951907,803073,555525,864626,414780,848041,224794,308278,954041,303559,281578,723913,347634,1035778,152503,768368,357378,212167,789793,629964,351421,224041,26329,115466,186055,463741,314445,810083,171310,656601,517812,116751,25722,204875,973646,400017,482181,525520,1024174,26737,420703,507515,679082,819566,774623,144456,545028,399945,485339,511155,197526,134352,657757,393975,505265,211438,273056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]