SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195984 LIMIT 1 [ RunTime:0.000972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195984 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37655,898636,461464,898238,474396,999922,46655,701391,216301,232552,545309,92103,1621,1039604,370590,429783,1012892,772920,353863,830927,29591,919631,74284,627907,928855,836334,885118,28099,1026967,294468,670674,721727,874895,867041,961754,343358,702705,114734,939768,870551,452251,770686,377960,368963,1004692,326861,955569,1000419,688777,986157,66505,153481,820355,141224,997952,159935,487061,491110,336817,489013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]