SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401139 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401139 [ RunTime:0.003756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476851,10530,538351,482974,857104,667144,147951,975736,470253,14700,1003388,827606,521788,178834,1038439,796691,91908,288111,911980,1012738,770351,252636,705198,818783,316847,798872,405953,753636,1001113,1034377,710495,672788,475110,936151,977819,383894,79389,88206,847604,867503,229099,379893,651822,828321,1017065,410016,1018749,427904,534911,387648,610945,166505,765977,562270,263935,495000,856656,970807,742112,9159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]