SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11403 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11403 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944968,530814,498289,560310,223944,685758,373898,541859,429422,938300,387883,773043,866777,411049,85573,61916,74454,704679,181144,138879,512556,752748,119397,53209,157053,104374,12305,906790,547731,65953,676930,564181,478869,827927,451764,944862,542503,689451,430252,769504,826741,92791,1008423,262017,567925,618006,890036,492326,157817,492504,548959,538999,118859,998273,862867,236824,678647,1039528,536167,810290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]