SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319634 LIMIT 1 [ RunTime:0.001320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319634 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438916,527210,156795,281326,957303,1019599,259187,949517,1015013,275495,588993,868319,104799,120951,581738,467237,478684,79352,30885,1018707,578794,190527,184264,162814,781308,485914,91253,414463,949430,821881,119330,531787,695512,637646,57047,454664,526333,527670,829616,473459,988217,1046173,443768,53689,916167,6298,797890,185500,677642,355547,755856,913240,827121,657476,879426,1000291,467520,510,578546,440543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]