SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542154 LIMIT 1 [ RunTime:0.001450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542154 [ RunTime:0.004707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200599,12641,86470,908818,546915,500655,644926,1001397,358638,235600,150356,42167,840525,750930,212678,109636,254735,612514,576602,980013,545680,240419,811182,508871,417461,47012,573214,1016312,34974,191086,804814,969424,386454,451032,366941,673231,273477,590999,282194,939273,1032579,499853,424490,7345,764392,862931,941201,209825,336441,553720,184152,565667,350955,727177,597014,29462,336451,99038,542223,564537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001711s ]