SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109271 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109271 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421024,481579,39938,966117,296417,976403,1031497,562551,580622,188051,31994,99025,560460,455851,339488,355788,142861,415665,665406,141494,272343,364574,68316,227715,541159,720979,549955,342990,402966,957122,495211,643683,545255,76443,818693,414608,626146,968374,92163,864699,481505,80604,584211,583687,681502,866752,481391,435721,368735,735198,471053,810107,200241,800787,640187,600122,255839,440835,683345,906685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]