SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011607 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011607 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937113,441092,262915,306950,827612,897177,761722,572399,127055,743154,299153,440820,731732,540388,182563,725159,175072,753707,202331,937484,203980,111662,490509,318874,578216,732487,787087,704659,718200,238432,39775,410391,761920,398943,433243,505170,749666,81843,7832,896931,516073,26224,226567,200793,783574,327715,1027955,544104,322383,986533,608869,313929,276681,913349,743495,486674,781231,954017,472614,339692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]