SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814028 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814028 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457903,845982,863942,161749,816142,914184,281976,1033141,251288,909179,899315,87868,933060,32261,85189,69829,502091,1047379,939020,341774,152171,824393,950113,966000,958565,854837,607777,320634,298636,462508,397577,1029053,835112,839227,555276,1003272,206115,687979,53149,147088,287386,294266,527412,936580,196514,539404,608006,664628,794749,277912,916498,956055,564521,1045026,940593,712801,236440,538241,160928,714422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]