SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002824s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 782041 LIMIT 1 [ RunTime:0.001182s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 782041 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333105,33634,107536,480438,100530,98363,101873,387103,127654,111345,422484,258065,1004239,149407,82332,64612,705327,406909,464930,925034,847197,840765,851263,1012236,803721,362951,425338,379796,977752,353963,346961,837454,682366,572042,919992,326397,383750,962428,568555,697123,270273,423198,604081,906766,1017890,687701,671846,600378,534971,864386,850312,538284,859201,490610,542165,807080,357322,650835,31091,852791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 782041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 782041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]