SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205161 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205161 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420005,173835,207977,355843,48282,402450,607640,550742,923200,32709,1020201,477234,899699,482571,620804,898800,1038828,425369,167631,457503,143802,569217,35133,15186,494966,149297,45840,984003,1036800,626952,671317,757238,731270,446187,106100,666877,108903,86599,196821,335110,530962,488170,207742,666394,414988,375113,782426,341336,797176,14590,850420,996113,543016,631833,278994,511764,557052,296893,122947,662869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]