SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000872s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022524 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022524 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953837,195355,79832,173673,49454,507835,61860,53376,82420,49350,41546,730696,291076,327274,192585,444634,665794,779134,1008203,1038469,910132,358590,542988,102383,581205,1031265,123019,353626,1002769,540612,458549,772003,961797,872280,996425,74678,1011949,276933,284321,487984,1048488,811865,939513,700734,254525,92915,1026661,748297,644577,203154,47842,91793,894125,405894,1043985,22045,965196,1000940,443805,577273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]