SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595097 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595097 [ RunTime:0.003700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448933,392094,520628,410004,52988,698278,881647,942887,170181,1012274,233470,761255,264323,581402,260904,774725,337426,387420,865580,489803,778717,609384,163634,259311,683168,849927,520708,592564,182346,965426,584602,330985,868012,430134,134067,854375,152759,288551,4119,623859,307254,144604,271163,863855,622655,87555,996682,518730,655548,399793,25197,927273,564491,837471,729404,567960,798792,124753,499700,580971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]