SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525518 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525518 [ RunTime:0.004213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890085,147754,572699,968800,495610,1042490,873965,137333,443321,935050,715478,431048,766401,754857,983642,237994,829849,515962,886245,257756,1028166,305208,1028938,73017,939171,260522,1038116,521456,536596,616095,577341,634640,281737,21379,986689,903502,399333,419290,197246,711322,152101,1007587,385377,767683,850406,212277,34426,969907,111115,483369,1007494,563510,990951,928775,682528,994802,1024225,348005,718057,140438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001661s ]