SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591913 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591913 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195509,144833,477146,453747,95586,1021737,353588,285811,930385,468564,242027,858172,362354,966764,635429,790851,234466,162154,382721,63269,199746,203723,1009106,878248,929162,871194,1005066,262179,438480,420609,687879,184501,826931,513445,280282,884796,464504,112527,367499,926881,745564,85596,343239,285755,1017555,661536,408997,307464,64641,21742,35665,238011,210220,216269,362472,643326,627931,58134,1031403,224094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]