SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567058 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567058 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012579,404118,4190,1024926,200030,792878,608453,572407,739994,77482,472180,369105,302453,922783,341108,803681,813892,764712,857513,436134,261424,193241,656546,388519,949241,548657,1036376,425951,655116,55988,664971,743700,878462,432041,714975,211216,198338,288627,765467,8817,414014,572155,498258,978248,396380,468159,823803,332285,25750,249838,33296,448398,200029,906303,198339,798218,265680,723090,998968,638869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005378s ]